EMT Practice Test

1. Question Content...

---

Question1: Universal Containers has a single dataset that contains the attainment and commission fields for all sales reps. Each sales rep should be able view the attainment data for each rep in their division. Each rep should only be able to see their own commission dat a.
Which option should a CRM Analytics consultant use to enforce this requirement?

Question2: Which capability can a consultant use if "Deploy without connecting to a Salesforce Object" is selected while deploying the model?

Question3: In a dataset, there are multiple boolean fields. When displayed on any dashboard, the boolean fields should all be displayed in the same way: a value of true should result in the display of the word "Yes" in green; a value of false should result in the display of the word "No" in red.
How should the consultant accomplish this?

Question4: A new picklist value was added for the Category field on the Account object. This field is already added as part of the Account object data sync and the respective recipe that uses this field.
The CRM Analytics team reports that when they start the recipe it runs successfully with no errors or warnings, but they are unable to See this new values on their existing dashboards.
What is the oridi4 of this issue?

Question5: CRM Analytics team is asked to build a Service Analytics dashboard for the service agents.
What are the main "Deep Design Thinking" principles the team should keep in mind during the discovery sessions?

Question6: A client has two datasets that are used across seven different dashboards. Three of these dashboards are used by marketing and four are used by sales. The client requires that only marketing can access the marketing dashboards and only sales can access the sales dashboards.
Which solution should a consultant recommend?

Question7: Universal Containers' sales team is looking to build a dashboard that shows the total revenue from their top 10 accounts (based on revenue) and make it dynamic with the filters of the dashboard.
Which action is required to accomplish this?

Question8: Universal Containers (UC) is looking to create a dashboard for whitespace analysis. UC wants to view a particular customer and see what similar customers have bought.
Which recipe transformation is helpful for the consultant to use while creating the dataset?

Question9: A CRM Analytics consultant has been asked to add a custom object to existing recipe. When trying to locate the object, the consultant can see only Direct Data and NOT the SFDC Local data sync.
How should the consultant resolve this?

Question10: The CRM Analytics consultant at Cloud Kicks (CK) notices that a specific dashboard is showing a different date and time from their locale. Upon investigating, they find that the recipe and datasets were created from a locale with a PST time zone while CK is in the CET time zone.
What led to this problem?

Question11: CRM Analytics team plans to enable data sync.
Which limit specific to data syne should the team consider before enabling the feature because it may impact existing jobs?

Question12: Cloud Kicks uses CRM Analytics for its sales reporting. A new manager needs access to CRM Analytics to see specific dashboards.
How should the system administrator give access to the Analytics
Studio app in the App Launcher?

Question13: A CRM Analytics consultant has prepared a CSV file to be uploaded to CRM Analytics. By mistake, one of the column headers is modified as random non-alphanumeric characters "*&**(&*(%", which went unnoticed prior to uploading the file.
What is the expected behavior of the uploaded CSV column?

Question14: A CRM Analytics consultant is asked to help a company report on its sales activity. The company wants to train some users to create dashboards. The company also wants one other specific team to be able to use the dashboards.
What should the consultant do to address these requirements?

Question15: A CRM Analytics consultant has been tasked with providing access to CRM Analytics for a few users. They should be able to view the data but unable to export it.
Which permission should the consultant make sure to NOT include?

Question16: Universal Containers (UC) recently activated data sync in the CRM Analytics data manager. After running the sync, UC notices that the aggregate sum of a field within the company's dataset is different than what they manually calculated by summing the same data in the Salesforce object.
What is causing the issue with the newly synced data?

Question17: Exhibit.

Universal Containers has a dashboard for sales managers to visualize the Year Over Year (YoY) growth of their customers. The formula used is:
YoY = [(This Year - Last Year) / Last Year] %
Based on the graphic, when there is not an account in the Last Year column, the YoY Growth shows null results. The sales managers want to replace it with 100% value.
What is the correct function to use?

Question18: A system administrator at Cloud Kicks creates a joined report to showcase the new business deals closing in the current quarter, which was well received by the business stakeholders. A manager wants to visualize this report on CRM Analytics.
The CRM Analytics consultant determines the report can be trended on CRM Analytics, but it's not working as expected.
What is causing the issue?

Question19: An CRM Analytics consultant creates a model to maximize the satisfaction of cases. They want to deploy the mode! and further use the model and predictions in an existing automated business process powered by Salesforce Flow.
What is the most efficient way to accomplish this?

Question20: A CRM Analytics consultant is asked to make changes to the current sales dashboard at Cloud Kicks. The dashboard is crucial to track the daily sales performance of the company and needs to be available for other users while the consultant works on the changes.
How should the consultant proceed to update the dashboard?

Question21: The below image shows a numeric outcome being deployed (Regression).

Which metric is used to calculate the performance of the model in production, specifically in the Model Manager?
The below image shows a numeric outcome being deployed (Regression).
Which metric is used to calculate the performance of the model in production, specifically in the Model Manager?

Question22: At Universal Containers, a dashboard is built to track sales metrics. The Opportunity amount field has conditional formatting added - it turns green for closed won and red for closed lost.
How should a CRM Analytics consultant enhance the dashboard design to become more accessible to users with color vision challenges?

Question23: A consultant runs the sharing inheritance coverage assessment for the Opportunity object and finds that some records exceed 400 sharing descriptors.
What should the consultant do?

Question24: The CRM Analytics consultant at Universal Containers notices that some users have access to sensitive data and dashboards they should not have access to in the Manager's app.
How should the consultant fix the problem?

Question25: What can a consultant accomplish in the Predictions page of a model?

Question26: Universal Containers wants to create two dashboards and has two user groups. The 'Regional Performance' dashboard should be accessible to sales reps and managers/executives to keep track of how sales reps are performing in each region. Sales reps must only be able to see data pertaining to their respective region. The 'National Performance' dashboard is using the same data as the other dashboard but should only be accessible to managers/executives to compare data across all regions.
In addition to row-level security to view only regional data, how should a consultant ensure that sales reps are unable to view the 'National Performance' dashboard?

Question27: Universal Containers has a dashboard for sales managers. They need the ability to visualize the number of Closed Won opportunities by month, quarter, or year, and then display the result in a single chart. A CRM Analytics consultant creates a custom query to display three values:
ClosedDate_month, ClosedDate_ quarter, and ClosedDate_year.
What should the consultant do next?

Question28: Which recommended technique should a CRM Analytics consultant
use to access CRM Analytics data from a remote app or website?

Question29: Universal Containers (UC) has a "Sales Manager" dashboard. UC has a compare table that has multiple groupings and columns added showing the Total and Subtotals of the numeric values. A consultant is asked to add additional groups to enhance details about UC's customers.
Which feature should the consultant use to make the navigation of the compare tables easier for the end user?

Question30: Universal Containers plans to upload target data from an external tool to CRM Analytics so it can calculate the sales team target attainments.
The target data changes every month, so the datasets need to be updated on a monthly basis. The target data is a CSV file that contains the Salesforce ID of the sales rep, the target amount, and the month of the target. For each sales rep, the file contains a target for every month of the current year as well as all previous years.
Based on this information, which operation should a consultant use with the Analytics External Data API to upload the file?

Question31: A consultant sets up a Sales Analytics templated app that is very useful for sales operations at Universal Containers (UC). UC wants to make sure all of the data assets associated with the app, including:
recipes, dataflows, connectors, Einstein Discovery models, and prediction definitions are refreshedeveryday at 6:00 AM EST.
How should the consultant proceed?

Question32: The CRM Analytics consultant at Universal Containers has set data syncs and recipe runs back to back. However, they notice that the data syncs and recipe run jobs fail repeatedly. Upon investigation, they realize the data syncs and recipes are tightly coupled which leads to too many runs being queued and eventually being canceled.
How should the consultant resolve this issue?

Question33: A manager at Cloud Kicks wants to separate and analyze accounts based on numeric information of its opportunity records. The data includes things like amount, quantity of products, contacts, and quotes.
How should the CRM Analytics consultant accomplish this?

Question34: Cloud Kicks (CK) wants to use CRM Analytics to analyze trends of its sales pipeline in order to accelerate the company's sales process. To do so, CK needs to know the average time an opportunity spends in each stage. The data can be found in the Opportunity History object, but the value is not pre-calculated in Salesforce, so a consultant recommends using a recipe to calculate it.
How should the consultant use a recipe to calculate the average time an opportunity spends in each stage?

Question35: The administrator at Cloud Kicks has been asked to sync data from an external object created in Salesforce into CRM Analytics.
What should the administrator keep in mind?

Question36: A CRM Analytics consultant at Cloud Kicks is trying to upload data using an External Data API and the CSV file with the data was uploaded successfully. Upon analyzing the data using a lens, they find they are unable to perform any mathematical operations as all the data and fields are treated as dimensions.
What is causing the problem?

Question37: Universal Containers has a dashboard for sales managers. They need to visualize the percentage of their opportunities in the pipeline in a Gauge chart. They want to customize the chart to keep track if they are below or beyond the target.

Which widget parameters should a consultant use?

Question38: A CRM Analytics consultant wants to move a dataflow to a recipe in order to use aggregation nodes. To do so, they use the Dataflow to Recipe convertor and the recipe runs successfully.
However, they are unable to see the aggregated data in the dataset.
What is causing the issue?

Question39: A consultant wants to understand what the important predictors are in a model.
Where is this information found?

Question40: The sole manager of a CRM Analytics app at Cloud Kicks is leaving the company.
What should the CRM Analytics consultant do to ensure the app remains accessible?

Question41: Universal Containers (UC) uses a Microsoft Azure SQL Data Warehouse to gather information about sales reps' objectives. UC wants to use CRM Analytics to gain insights from this data and automatically load it into a CRM Analytics dataset daily. The data also needs to be transformed and merged with data from the company's org.
Which CRM Analytics user interface features should be used to complete these requirements?

Question42: A system administrator and a CRM Analytics consultant are working together on deploying arecipe/dataflow and a dataset to another org. Prior to this deployment, a package was deployed with all the custom fields used in the dataflow and dataset.
While running the recipe/dataflow in the target environment, the consultant encounters multiple errors related to these custom fields.
How should this be resolved?

Question43: A CRM Analytics consultant is performing column profiling on dimension column in a recipe. Newly-added rows are not being considered in the Results tab of the profile even though a sync was run for that specific object.
What is causing the issue?

Question44: Universal Containers is setting up a Sales Analytics app to track the sales performance across all regions. The role hierarchy is well-structured with separate branches for various global regions.
Viewer access has been provided to the regional sales reps based on the following roles.
* Regional Sales - APAC
* Regional Sales - EMEA
* Regional Sales - LATAM
* Regional Sales - NA
The CRM Analytics project team receives a request to extend Editor
access to the app to 20 'Superusers' across all regions.
What is the optimal solution?

Question45: A consultant is building a CRM Analytics dashboard for Universal
Containers. The consultant has enabled data sync to increase the
speed of datasets refreshing.
How often will the data on the dashboard be refreshed?

Question46: A CRM Analytics consultant is reviewing results from an Einstein Discovery story with a business user. They agree with the findings but notice that none of the fields used in the story have a correlation value greater than 4%. The client is now concerned that the model may not be good enough to deploy.
Which action should the consultant take?

Question47: A company realizes it has a lot of rich information around its cases, but unfortunately, most of this is unstructured/textual dat a. The company is exploring how to include some of this information in its case prioritization.
Which option within CRM Analytics should a consultant leverage?

Question48: Universal Containers (UC) recently activated data sync in the CRM Analytics data manager. After running the sync, UC notices that the aggregate sum of a field within the company's dataset is different than what they manually calculated by summing the same data in the Salesforce object.
What is causing the issue with the newly synced data?

Question49: What is the purpose of the CRM Analytics Dashboard Inspector?

Question50: Cloud Kicks' Salesforce org has multiple currencies enabled. This company's business intelligence team uses CRM Analytics to build a dataflow/recipe that creates a dataset, "OpportunityDataSet", which is populated with data extracted from Opportunity. One of the extracted fields is the standard field, Amount.
Which currency will the Amount values be shown in "OpportunityDataSet"?

Question51: A dashboard designer at Cloud Kicks creates a dashboard in CRM Analytics. The designer notices fields display on the dashboard with their API labels, such as "AccountId.Industry", and wants to change this behavior.
The designer also notices that the fields and their order appear to randomly change when a values table is created.
What should the CRM Analytics consultant explain to help the designer?

Question52: A team of CRM Analytics developers has been working on an existing recipe to add new derived fields. The edited version has been failing ever since, and management is requesting that the dashboard show refreshed data while they work on the edits.
How can the developers add new fields while keeping the dataset refreshed?

Question53: A company wants to create a timeline chart to visualize the evolution of its Closed Won opportunities.

What are the required parameters to build a lens that displays output similar to the image shown?

Question54: Universal Containers (UC) builds three Einstein Discovery models in Salesforce to predict and maximize its revenue per customer. The models are for every region UC has a business: EMEA, AMER, and APAC.
How should a consultant help UC deploy the three Einstein models to Salesforce?

Question55: What are various ways to incorporate blank space in a CRM Analytics dashboard?